{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Spieldaten","Heim","Gast","Spielplan","Spielbericht MOFDV m. Higlights"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Spieldaten","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,20,8],[4,5,7,8],[11,5,15,8],[4,1,4,3],[5,1,5,3],[9,1,9,3],[11,1,11,3],[12,1,12,3],[7,1,7,3]]}
["Spieldaten"]
[]
["Bezirksliga","Gruppe"]
[]
["Heimmannschaft",null,null,null,null,"In den grünen Feldern sind die jeweiligen Daten einzutragen. Mit diesen werden dann die weiteren Register automatisch befüllt. Am Schluss nicht das Spielende vergessen."]
["Gastmannschaft"]
[]
["Spielort"]
[]
["Spieltag"]
[]
["Spielbeginn",null,null,null,null,"Mit der Tastenkombination \"Strg + l\" werden die Daten in allen Registern gelöscht, so dass das nächste Spiel erfasst werden kann. Die Felder \"Heimmannschaft\", \"Spielort\" und \"Spielbeginn\" werden nicht zurückgesetzt, können aber überschrieben werden."]
["Spielende"]
[]
[]
["Daten zurücksetzen:","Strg + l"]
[]
["Liebe Dartfreunde,\ndieses kleine Excel-Tool habe ich entworfen, um uns die Spielerfassung am Spieltag und die Erstellung des dazugehörigen Spielberichts am PC so einfach wie möglich zu machen. Ich kann allerdings keine Gewähr dafür übernehmen, dass es komplett fehlerfrei ist. Bitte macht einfach vor dem ersten Einsatz mal ein \"Probespiel\" am PC um Euch mit dem Handling vertraut zu machen. Solltet Ihr dabei Fehler finden, lasst mich das bitte wissen (bernd-feist@t-online.de). Auch für konstruktive Anregungen oder Verbesserungsvorschläge bin ich immer offen. \nNoch ein kleiner Tipp: Im Excel gibt es den \"Vollbildmodus\". Der ist am Spieltag selbst sehr hilfreich, weil dann alle Menüs und Buttons ausgeblendet werden und vom Spielplan am meisten auf dem Bildschirm zu sehen ist.\n\nViel Spaß mit dem Programm und \"allways Good Darts\" wünscht Euch Euer Dartkollege Bernd"]

{"sheet":"Heim","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,8],[0,0,0,12],[2,0,2,12],[4,1,4,8],[5,1,5,8],[11,1,11,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[5,10,12,12]]}
["Mannschaftsaufstellung - Heimmannschaft"]
[]
[{"$f":"IF(Spieldaten!B5=\"\",\"\",Spieldaten!B5)","v":""}]
[]
["Pos.","Spielername"]
["H1",null,null,null,null,null,null,null,null,null,"Bitte hier die Mannschaftsaufstellung der Heimmannschaft eintragen.\nH1 - H4: Startaufstellung\nHE1 - HE4: Einwechselspieler\n\nDie Ersatzspielerkönnen hier gleich komplett eingetragen werden. Die Auswechslungen erfolgen im Register \"Spielplan\" durch Eintragung des jeweiligen Kürzel (z.B. HE1) beim entsprechenden Spiel."]
["H2"]
["H3"]
["H4"]
["HE1"]
["HE2"]
["HE3"]
["HE4"]

{"sheet":"Gast","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,1,4,8],[5,1,5,8],[0,0,0,12],[2,0,2,12],[11,1,11,8],[5,10,12,12],[12,1,12,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8]]}
["Mannschaftsaufstellung - Gastmannschaft"]
[]
[{"$f":"IF(Spieldaten!B6=\"\",\"\",Spieldaten!B6)","v":""}]
[]
["Pos.","Spielername"]
["G1",null,null,null,null,null,null,null,null,null,"Bitte hier die Mannschaftsaufstellung der Gastmannschaft eintragen.\nG1 - G4: Startaufstellung\nGE1 - GE4: Einwechselspieler\n\nDie Ersatzspielerkönnen hier gleich komplett eingetragen werden. Die Auswechslungen erfolgen im Register \"Spielplan\" durch Eintragung des jeweiligen Kürzel (z.B. GE1) beim entsprechenden Spiel."]
["G2"]
["G3"]
["G4"]
["GE1"]
["GE2"]
["GE3"]
["GE4"]

{"sheet":"Spielplan","index":3,"n_rows":36,"n_cols":39,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,2,33,5],[32,2,32,3],[32,4,32,5],[26,4,26,5],[21,4,21,5],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[22,3,23,3],[24,3,25,3],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[32,8,32,38],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[11,0,11,1],[16,0,16,1],[21,0,21,1],[26,0,26,1],[6,4,6,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[7,4,7,5],[16,4,16,5],[12,7,15,7],[12,8,12,18],[12,20,12,30],[13,8,13,18],[13,20,13,30],[14,8,14,18],[14,20,14,30],[15,8,15,18],[9,8,9,18],[9,20,9,30],[7,20,7,30],[8,20,8,30],[7,8,7,18],[8,8,8,18],[7,7,10,7],[8,4,8,5],[9,4,9,5],[10,4,10,5],[10,8,10,18],[10,20,10,30],[5,36,5,38],[5,32,5,34],[3,0,3,6],[3,32,3,38],[0,8,0,30],[3,8,3,30],[2,8,2,30],[1,8,1,30],[2,0,2,6],[0,0,0,6],[0,32,0,38],[2,32,2,38],[34,8,34,38],[33,8,33,38],[24,8,24,18],[22,32,23,32],[22,33,23,33],[22,34,23,34],[22,36,23,36],[22,37,23,37],[22,38,23,38],[24,32,25,32],[24,33,25,33],[24,34,25,34],[24,36,25,36],[24,37,25,37],[24,38,25,38],[22,8,22,18],[22,20,22,30],[29,8,29,18],[29,20,29,30],[30,8,30,18],[30,20,30,30],[27,7,30,7],[27,8,27,18],[27,20,27,30],[28,8,28,18],[28,20,28,30],[17,7,20,7],[19,4,19,5],[20,20,20,30],[17,4,17,5],[18,4,18,5],[19,20,19,30],[17,8,17,18],[17,20,17,30],[22,7,25,7],[23,8,23,18],[22,19,23,19],[24,19,25,19],[23,20,23,30],[24,20,24,30],[25,8,25,18],[25,20,25,30],[35,8,35,38],[12,3,13,3],[12,19,13,19],[12,32,13,32],[12,33,13,33],[12,34,13,34],[12,36,13,36],[12,37,13,37],[12,38,13,38],[14,3,15,3],[14,19,15,19],[14,32,15,32],[14,33,15,33],[14,34,15,34],[14,36,15,36],[14,37,15,37],[14,38,15,38],[15,4,15,5],[15,20,15,30],[18,8,18,18],[18,20,18,30],[20,4,20,5],[19,8,19,18],[20,8,20,18]]}
[{"$f":"IF(SUM(AK8:AK31)=0,0,SUM(AK8:AK31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(Spieldaten!B5=\"\",\"\",Spieldaten!B5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG8:AG31)=0,0,SUM(AG8:AG31))","v":0}]
[null,null,null,":",null,null,null,null,":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":"]
[{"$f":"IF(SUM(AM8:AM31)=0,0,SUM(AM8:AM31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(Spieldaten!B6=\"\",\"\",Spieldaten!B6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AI8:AI31)=0,0,SUM(AI8:AI31))","v":0}]
["Spielstand",null,null,null,null,null,null,null,"Spielplan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legs"]
[]
["Spielpaarungen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legs",null,null,null,"Punkte"]
["Spieler",null,"HE",null,"Spieler",null,"GE"]
["H1",null,null,":","G1",null,null,"Einzel",{"$f":"IF(C8=\"\",IF(A8=\"H1\",Heim!$B$6,IF(A8=\"H2\",Heim!$B$7,IF(A8=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C8=\"HE1\",Heim!$B$10,IF(C8=\"HE2\",Heim!$B$11,IF(C8=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G8=\"\",IF(E8=\"G1\",Gast!$B$6,IF(E8=\"G2\",Gast!$B$7,IF(E8=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G8=\"GE1\",Gast!$B$10,IF(G8=\"GE2\",Gast!$B$11,IF(G8=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,{"$f":"IF(AG8=\"\",\"\",IF(AG8>AI8,1,0))","v":""},":",{"$f":"IF(AG8=\"\",\"\",IF(AG8>AI8,0,1))","v":""}]
["H2",null,null,":","G2",null,null,null,{"$f":"IF(C9=\"\",IF(A9=\"H1\",Heim!$B$6,IF(A9=\"H2\",Heim!$B$7,IF(A9=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C9=\"HE1\",Heim!$B$10,IF(C9=\"HE2\",Heim!$B$11,IF(C9=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G9=\"\",IF(E9=\"G1\",Gast!$B$6,IF(E9=\"G2\",Gast!$B$7,IF(E9=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G9=\"GE1\",Gast!$B$10,IF(G9=\"GE2\",Gast!$B$11,IF(G9=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,{"$f":"IF(AG9=\"\",\"\",IF(AG9>AI9,1,0))","v":""},":",{"$f":"IF(AG9=\"\",\"\",IF(AG9>AI9,0,1))","v":""}]
["H3",null,null,":","G3",null,null,null,{"$f":"IF(C10=\"\",IF(A10=\"H1\",Heim!$B$6,IF(A10=\"H2\",Heim!$B$7,IF(A10=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C10=\"HE1\",Heim!$B$10,IF(C10=\"HE2\",Heim!$B$11,IF(C10=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G10=\"\",IF(E10=\"G1\",Gast!$B$6,IF(E10=\"G2\",Gast!$B$7,IF(E10=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G10=\"GE1\",Gast!$B$10,IF(G10=\"GE2\",Gast!$B$11,IF(G10=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H4",null,null,":","G4",null,null,null,{"$f":"IF(C11=\"\",IF(A11=\"H1\",Heim!$B$6,IF(A11=\"H2\",Heim!$B$7,IF(A11=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C11=\"HE1\",Heim!$B$10,IF(C11=\"HE2\",Heim!$B$11,IF(C11=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G11=\"\",IF(E11=\"G1\",Gast!$B$6,IF(E11=\"G2\",Gast!$B$7,IF(E11=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G11=\"GE1\",Gast!$B$10,IF(G11=\"GE2\",Gast!$B$11,IF(G11=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["Spieler",null,"HE",null,"Spieler",null,"GE"]
["H1",null,null,":","G1",null,null,"Doppel",{"$f":"IF(C13=\"\",IF(A13=\"H1\",Heim!$B$6,IF(A13=\"H2\",Heim!$B$7,IF(A13=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C13=\"HE1\",Heim!$B$10,IF(C13=\"HE2\",Heim!$B$11,IF(C13=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G13=\"\",IF(E13=\"G1\",Gast!$B$6,IF(E13=\"G2\",Gast!$B$7,IF(E13=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G13=\"GE1\",Gast!$B$10,IF(G13=\"GE2\",Gast!$B$11,IF(G13=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,{"$f":"IF(AG13=\"\",\"\",IF(AG13>AI13,1,0))","v":""},":",{"$f":"IF(AG13=\"\",\"\",IF(AG13>AI13,0,1))","v":""}]
["H3",null,null,null,"G2",null,null,null,{"$f":"IF(C14=\"\",IF(A14=\"H1\",Heim!$B$6,IF(A14=\"H2\",Heim!$B$7,IF(A14=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C14=\"HE1\",Heim!$B$10,IF(C14=\"HE2\",Heim!$B$11,IF(C14=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G14=\"\",IF(E14=\"G1\",Gast!$B$6,IF(E14=\"G2\",Gast!$B$7,IF(E14=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G14=\"GE1\",Gast!$B$10,IF(G14=\"GE2\",Gast!$B$11,IF(G14=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",""]
["H4",null,null,":","G3",null,null,null,{"$f":"IF(C15=\"\",IF(A15=\"H1\",Heim!$B$6,IF(A15=\"H2\",Heim!$B$7,IF(A15=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C15=\"HE1\",Heim!$B$10,IF(C15=\"HE2\",Heim!$B$11,IF(C15=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G15=\"\",IF(E15=\"G1\",Gast!$B$6,IF(E15=\"G2\",Gast!$B$7,IF(E15=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G15=\"GE1\",Gast!$B$10,IF(G15=\"GE2\",Gast!$B$11,IF(G15=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H2",null,null,null,"G4",null,null,null,{"$f":"IF(C16=\"\",IF(A16=\"H1\",Heim!$B$6,IF(A16=\"H2\",Heim!$B$7,IF(A16=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C16=\"HE1\",Heim!$B$10,IF(C16=\"HE2\",Heim!$B$11,IF(C16=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G16=\"\",IF(E16=\"G1\",Gast!$B$6,IF(E16=\"G2\",Gast!$B$7,IF(E16=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G16=\"GE1\",Gast!$B$10,IF(G16=\"GE2\",Gast!$B$11,IF(G16=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",""]
["Spieler",null,"HE",null,"Spieler",null,"GE"]
["H1",null,null,":","G2",null,null,"Einzel",{"$f":"IF(C18=\"\",IF(A18=\"H1\",Heim!$B$6,IF(A18=\"H2\",Heim!$B$7,IF(A18=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C18=\"HE1\",Heim!$B$10,IF(C18=\"HE2\",Heim!$B$11,IF(C18=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G18=\"\",IF(E18=\"G1\",Gast!$B$6,IF(E18=\"G2\",Gast!$B$7,IF(E18=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G18=\"GE1\",Gast!$B$10,IF(G18=\"GE2\",Gast!$B$11,IF(G18=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,{"$f":"IF(AG18=\"\",\"\",IF(AG18>AI18,1,0))","v":""},":",{"$f":"IF(AG18=\"\",\"\",IF(AG18>AI18,0,1))","v":""}]
["H2",null,null,":","G1",null,null,null,{"$f":"IF(C19=\"\",IF(A19=\"H1\",Heim!$B$6,IF(A19=\"H2\",Heim!$B$7,IF(A19=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C19=\"HE1\",Heim!$B$10,IF(C19=\"HE2\",Heim!$B$11,IF(C19=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G19=\"\",IF(E19=\"G1\",Gast!$B$6,IF(E19=\"G2\",Gast!$B$7,IF(E19=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G19=\"GE1\",Gast!$B$10,IF(G19=\"GE2\",Gast!$B$11,IF(G19=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H3",null,null,":","G4",null,null,null,{"$f":"IF(C20=\"\",IF(A20=\"H1\",Heim!$B$6,IF(A20=\"H2\",Heim!$B$7,IF(A20=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C20=\"HE1\",Heim!$B$10,IF(C20=\"HE2\",Heim!$B$11,IF(C20=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G20=\"\",IF(E20=\"G1\",Gast!$B$6,IF(E20=\"G2\",Gast!$B$7,IF(E20=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G20=\"GE1\",Gast!$B$10,IF(G20=\"GE2\",Gast!$B$11,IF(G20=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H4",null,null,":","G3",null,null,null,{"$f":"IF(C21=\"\",IF(A21=\"H1\",Heim!$B$6,IF(A21=\"H2\",Heim!$B$7,IF(A21=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C21=\"HE1\",Heim!$B$10,IF(C21=\"HE2\",Heim!$B$11,IF(C21=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G21=\"\",IF(E21=\"G1\",Gast!$B$6,IF(E21=\"G2\",Gast!$B$7,IF(E21=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G21=\"GE1\",Gast!$B$10,IF(G21=\"GE2\",Gast!$B$11,IF(G21=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["Spieler",null,"HE",null,"Spieler",null,"GE"]
["H1",null,null,":","G3",null,null,"Doppel",{"$f":"IF(C23=\"\",IF(A23=\"H1\",Heim!$B$6,IF(A23=\"H2\",Heim!$B$7,IF(A23=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C23=\"HE1\",Heim!$B$10,IF(C23=\"HE2\",Heim!$B$11,IF(C23=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G23=\"\",IF(E23=\"G1\",Gast!$B$6,IF(E23=\"G2\",Gast!$B$7,IF(E23=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G23=\"GE1\",Gast!$B$10,IF(G23=\"GE2\",Gast!$B$11,IF(G23=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,{"$f":"IF(AG23=\"\",\"\",IF(AG23>AI23,1,0))","v":""},":",{"$f":"IF(AG23=\"\",\"\",IF(AG23>AI23,0,1))","v":""}]
["H4",null,null,null,"G4",null,null,null,{"$f":"IF(C24=\"\",IF(A24=\"H1\",Heim!$B$6,IF(A24=\"H2\",Heim!$B$7,IF(A24=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C24=\"HE1\",Heim!$B$10,IF(C24=\"HE2\",Heim!$B$11,IF(C24=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G24=\"\",IF(E24=\"G1\",Gast!$B$6,IF(E24=\"G2\",Gast!$B$7,IF(E24=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G24=\"GE1\",Gast!$B$10,IF(G24=\"GE2\",Gast!$B$11,IF(G24=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",""]
["H3",null,null,":","G1",null,null,null,{"$f":"IF(C25=\"\",IF(A25=\"H1\",Heim!$B$6,IF(A25=\"H2\",Heim!$B$7,IF(A25=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C25=\"HE1\",Heim!$B$10,IF(C25=\"HE2\",Heim!$B$11,IF(C25=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G25=\"\",IF(E25=\"G1\",Gast!$B$6,IF(E25=\"G2\",Gast!$B$7,IF(E25=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G25=\"GE1\",Gast!$B$10,IF(G25=\"GE2\",Gast!$B$11,IF(G25=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H2",null,null,null,"G2",null,null,null,{"$f":"IF(C26=\"\",IF(A26=\"H1\",Heim!$B$6,IF(A26=\"H2\",Heim!$B$7,IF(A26=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C26=\"HE1\",Heim!$B$10,IF(C26=\"HE2\",Heim!$B$11,IF(C26=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G26=\"\",IF(E26=\"G1\",Gast!$B$6,IF(E26=\"G2\",Gast!$B$7,IF(E26=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G26=\"GE1\",Gast!$B$10,IF(G26=\"GE2\",Gast!$B$11,IF(G26=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",""]
["Spieler",null,"HE",null,"Spieler",null,"GE"]
["H1",null,null,":","G3",null,null,"Einzel",{"$f":"IF(C28=\"\",IF(A28=\"H1\",Heim!$B$6,IF(A28=\"H2\",Heim!$B$7,IF(A28=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C28=\"HE1\",Heim!$B$10,IF(C28=\"HE2\",Heim!$B$11,IF(C28=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G28=\"\",IF(E28=\"G1\",Gast!$B$6,IF(E28=\"G2\",Gast!$B$7,IF(E28=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G28=\"GE1\",Gast!$B$10,IF(G28=\"GE2\",Gast!$B$11,IF(G28=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,{"$f":"IF(AG28=\"\",\"\",IF(AG28>AI28,1,0))","v":""},":",{"$f":"IF(AG28=\"\",\"\",IF(AG28>AI28,0,1))","v":""}]
["H2",null,null,":","G4",null,null,null,{"$f":"IF(C29=\"\",IF(A29=\"H1\",Heim!$B$6,IF(A29=\"H2\",Heim!$B$7,IF(A29=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C29=\"HE1\",Heim!$B$10,IF(C29=\"HE2\",Heim!$B$11,IF(C29=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G29=\"\",IF(E29=\"G1\",Gast!$B$6,IF(E29=\"G2\",Gast!$B$7,IF(E29=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G29=\"GE1\",Gast!$B$10,IF(G29=\"GE2\",Gast!$B$11,IF(G29=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H3",null,null,":","G1",null,null,null,{"$f":"IF(C30=\"\",IF(A30=\"H1\",Heim!$B$6,IF(A30=\"H2\",Heim!$B$7,IF(A30=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C30=\"HE1\",Heim!$B$10,IF(C30=\"HE2\",Heim!$B$11,IF(C30=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G30=\"\",IF(E30=\"G1\",Gast!$B$6,IF(E30=\"G2\",Gast!$B$7,IF(E30=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G30=\"GE1\",Gast!$B$10,IF(G30=\"GE2\",Gast!$B$11,IF(G30=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
["H4",null,null,":","G2",null,null,null,{"$f":"IF(C31=\"\",IF(A31=\"H1\",Heim!$B$6,IF(A31=\"H2\",Heim!$B$7,IF(A31=\"H3\",Heim!$B$8,Heim!$B$9))),IF(C31=\"HE1\",Heim!$B$10,IF(C31=\"HE2\",Heim!$B$11,IF(C31=\"HE3\",Heim!$B$12,Heim!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,":",{"$f":"IF(G31=\"\",IF(E31=\"G1\",Gast!$B$6,IF(E31=\"G2\",Gast!$B$7,IF(E31=\"G3\",Gast!$B$8,Gast!$B$9))),IF(G31=\"GE1\",Gast!$B$10,IF(G31=\"GE2\",Gast!$B$11,IF(G31=\"GE3\",Gast!$B$12,Gast!$B$13))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,"",":",""]
[]
[null,null,null,null,null,null,null,null,"Die Inhalte bzw. die Werte von roten und blauen Feldern werden automatisch berechnet."]
[null,null,null,null,null,null,null,null,"Eintragung und Änderungen können nur in den grünmarkierten Feldern vorgenommen werden"]
[null,null,null,null,null,null,null,null,"Beim Einsatz von Ersatzspielern werden diese beim jeweiligen Spiel in der grünmarkierten Spalte \"HE\" bzw. \"GE\" mit dem jeweiligen Kürzel (z.B. HE1 oder GE2) aus der Mannschaftsaufstellung eintragen. Bei Rückwechsel bleibt die Spalte \"HE\" bzw. \"GE\" wieder leer."]
[null,null,null,null,null,null,null,null,"Der freie Wechsel der Doppelspieler kann in der ersten Spalte \"Spieler\" durch überschreiben erfolgen. Werden Ersatzspieler in den Doppel eingesetzt, müssen diese wieder in der Spalte \"HE\" bzw. \"GE\" eingetragen werden."]

{"sheet":"Spielbericht MOFDV m. Higlights","index":4,"n_rows":105,"n_cols":35,"rows_kept":105,"cut":false,"hidden":false,"merged":[[24,3,24,9],[34,3,34,9],[34,10,34,11],[34,15,34,21],[34,22,34,23],[31,10,31,11],[31,15,31,21],[31,22,31,23],[32,3,32,9],[32,10,32,11],[32,15,32,21],[32,22,32,23],[33,3,33,9],[33,10,33,11],[33,15,33,21],[33,22,33,23],[23,3,23,9],[14,3,14,9],[12,22,12,23],[13,15,13,21],[13,22,13,23],[21,15,21,21],[22,15,22,21],[18,22,19,23],[4,34,4,51],[5,34,6,51],[7,34,8,51],[11,22,11,23],[10,3,10,9],[10,10,10,11],[10,15,10,21],[10,22,10,23],[10,25,10,27],[10,29,10,31],[11,3,11,9],[14,10,14,11],[16,22,17,23],[16,25,17,25],[16,26,17,26],[16,27,17,27],[16,29,17,29],[16,30,17,30],[16,31,17,31],[14,22,14,23],[17,3,17,9],[0,7,0,17],[0,19,0,31],[3,7,3,17],[4,7,4,17],[4,19,4,22],[3,25,3,27],[4,25,4,27],[4,29,4,31],[3,29,3,31],[3,19,3,22],[1,7,1,17],[1,19,1,31],[11,0,14,0],[16,0,19,0],[21,0,24,0],[23,15,23,21],[12,3,12,9],[12,10,12,11],[13,3,13,9],[13,10,13,11],[16,15,16,21],[18,15,18,21],[19,3,19,9],[16,3,16,9],[19,15,19,21],[12,15,12,21],[17,15,17,21],[14,15,14,21],[21,3,21,9],[22,3,22,9],[11,10,11,11],[11,15,11,21],[16,10,17,11],[18,10,19,11],[24,15,24,21],[18,3,18,9],[26,0,29,0],[53,1,53,31],[54,1,54,31],[48,25,48,27],[48,29,48,31],[47,25,47,31],[49,2,49,9],[50,2,50,9],[49,13,49,19],[50,13,50,19],[29,3,29,9],[29,15,29,21],[26,3,26,9],[26,15,26,21],[27,3,27,9],[27,15,27,21],[31,0,34,0],[31,3,31,9],[28,3,28,9],[28,15,28,21],[28,10,29,11],[28,22,29,23],[28,25,29,25],[28,26,29,26],[64,17,64,21],[63,17,63,21],[63,15,63,16],[63,22,63,26],[64,22,64,26],[64,0,64,1],[64,2,64,14],[64,15,64,16],[62,0,63,1],[62,2,63,14],[62,15,62,26],[65,0,65,1],[65,2,65,14],[65,15,65,16],[65,17,65,21],[65,22,65,26],[66,0,66,1],[66,2,66,14],[66,15,66,16],[66,17,66,21],[66,22,66,26],[67,0,67,1],[67,2,67,14],[67,15,67,16],[67,17,67,21],[67,22,67,26],[68,0,68,1],[68,2,68,14],[68,15,68,16],[68,17,68,21],[68,22,68,26],[69,0,69,1],[69,2,69,14],[69,15,69,16],[69,17,69,21],[69,22,69,26],[70,0,70,1],[70,2,70,14],[70,15,70,16],[70,17,70,21],[70,22,70,26],[71,0,71,1],[71,2,71,14],[71,15,71,16],[71,17,71,21],[71,22,71,26],[84,0,85,1],[84,2,85,14],[84,15,84,26],[85,15,85,16],[85,17,85,21],[85,22,85,26],[73,15,73,26],[74,15,74,16],[74,17,74,21],[74,22,74,26],[75,0,75,1],[73,0,74,1],[73,2,74,14],[75,15,76,16],[75,17,76,21],[75,22,76,26],[77,15,78,16],[77,17,78,21],[77,22,78,26],[86,15,86,16],[86,17,86,21],[86,22,86,26],[87,0,87,1],[87,2,87,14],[87,15,87,16],[87,17,87,21],[87,22,87,26],[88,17,88,21],[82,0,82,1],[82,2,82,14],[92,22,92,26],[93,0,93,1],[93,2,93,14],[93,15,93,16],[93,17,93,21],[93,22,93,26],[90,0,90,1],[90,2,90,14],[90,15,90,16],[90,17,90,21],[90,22,90,26],[91,0,91,1],[91,2,91,14],[91,15,91,16],[91,17,91,21],[91,22,91,26],[88,22,88,26],[89,0,89,1],[89,2,89,14],[89,15,89,16],[89,17,89,21],[89,22,89,26],[80,2,80,14],[81,0,81,1],[81,2,81,14],[99,0,99,1],[99,2,99,14],[99,15,100,16],[99,17,100,21],[96,17,96,21],[75,2,75,14],[86,0,86,1],[86,2,86,14],[100,2,100,14],[92,0,92,1],[92,2,92,14],[92,15,92,16],[92,17,92,21],[78,0,78,1],[78,2,78,14],[79,0,79,1],[79,2,79,14],[76,0,76,1],[88,0,88,1],[88,2,88,14],[88,15,88,16],[99,22,100,26],[100,0,100,1],[95,0,96,1],[95,2,96,14],[95,15,95,26],[96,15,96,16],[76,2,76,14],[77,0,77,1],[77,2,77,14],[96,22,96,26],[97,0,97,1],[97,2,97,14],[97,15,98,16],[97,17,98,21],[97,22,98,26],[98,0,98,1],[98,2,98,14],[79,15,80,16],[79,17,80,21],[79,22,80,26],[81,15,82,16],[81,17,82,21],[81,22,82,26],[80,0,80,1],[103,0,103,1],[103,2,103,14],[103,15,104,16],[103,17,104,21],[103,22,104,26],[104,0,104,1],[104,2,104,14],[101,0,101,1],[101,2,101,14],[101,15,102,16],[101,17,102,21],[101,22,102,26],[102,0,102,1],[102,2,102,14],[18,25,19,25],[18,26,19,26],[18,27,19,27],[18,29,19,29],[18,30,19,30],[18,31,19,31],[26,25,27,25],[26,26,27,26],[26,27,27,27],[26,29,27,29],[26,30,27,30],[26,31,27,31],[28,27,29,27],[28,29,29,29],[28,30,29,30],[28,31,29,31],[21,10,21,11],[21,22,21,23],[22,10,22,11],[22,22,22,23],[23,10,23,11],[23,22,23,23],[24,10,24,11],[24,22,24,23],[26,10,27,11],[26,22,27,23]]}
[null,null,null,null,null,null,null,"Heimteam",null,null,null,null,null,null,null,null,null,null,null,"Gastteam"]
[null,null,null,null,null,null,null,{"$f":"IF(Spieldaten!B5=\"\",\"\",Spieldaten!B5)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spieldaten!B6=\"\",\"\",Spieldaten!B6)","v":""}]
[]
[null,null,null,null,null,null,null,"Spielort",null,null,null,null,null,null,null,null,null,null,null,"Datum",null,null,null,null,null,"Beginn",null,null,null,"Ende"]
[null,null,null,null,null,null,null,{"$f":"IF(Spieldaten!B8=\"\",\"\",Spieldaten!B8)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spieldaten!B10=\"\",\"\",Spieldaten!B10)","v":""},null,null,null,null,null,{"$f":"IF(Spieldaten!B12=\"\",\"\",Spieldaten!B12)","v":""},null,null,null,{"$f":"IF(Spieldaten!B13=\"\",\"\",Spieldaten!B13)","v":""},null,null,null,null,"Nicht vergessen die Endzeit im Register \"Spieldaten\" einzugeben."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Die Highlights können unten im Anschluss an den Spielberichtsboden eingetragen werden."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dazu kann die Seite 2 des Spielberichtsbogen auch schon vor dem Spiel ausgedruckt und am Board bereitgelegt werden."]
[null,"Spielbericht",null,null,null,null,{"$f":"Spieldaten!A3","v":"Bezirksliga"},null,null,null,null,null,null,null,"Gruppe",null,null,null,{"$f":"IF(Spieldaten!D3=\"\",\"\",Spieldaten!D3)","v":""}]
[]
[null,null,"HE","Name, Vorname",null,null,null,null,null,null,"Highlights",null,null,null,"GE","Name, Vorname",null,null,null,null,null,null,"Highlights",null,null,"Leg",null,null,null,"Punkte"]
["Einzel",{"$f":"Spielplan!A8","v":"H1"},{"$f":"IF(Spielplan!C8=\"\",\"\",Spielplan!C8)","v":""},{"$f":"IF(Spielplan!I8=\"\",\"\",Spielplan!I8)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E8","v":"G1"},{"$f":"IF(Spielplan!G8=\"\",\"\",Spielplan!G8)","v":""},{"$f":"IF(Spielplan!U8=\"\",\"\",Spielplan!U8)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG8=\"\",\"\",Spielplan!AG8)","v":""},":",{"$f":"IF(Spielplan!AI8=\"\",\"\",Spielplan!AI8)","v":""},null,{"$f":"IF(Spielplan!AK8=\"\",\"\",Spielplan!AK8)","v":""},":",{"$f":"IF(Spielplan!AM8=\"\",\"\",Spielplan!AM8)","v":""}]
[null,{"$f":"Spielplan!A9","v":"H2"},{"$f":"IF(Spielplan!C9=\"\",\"\",Spielplan!C9)","v":""},{"$f":"IF(Spielplan!I9=\"\",\"\",Spielplan!I9)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E9","v":"G2"},{"$f":"IF(Spielplan!G9=\"\",\"\",Spielplan!G9)","v":""},{"$f":"IF(Spielplan!U9=\"\",\"\",Spielplan!U9)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG9=\"\",\"\",Spielplan!AG9)","v":""},":",{"$f":"IF(Spielplan!AI9=\"\",\"\",Spielplan!AI9)","v":""},null,{"$f":"IF(Spielplan!AK9=\"\",\"\",Spielplan!AK9)","v":""},":",{"$f":"IF(Spielplan!AM9=\"\",\"\",Spielplan!AM9)","v":""}]
[null,{"$f":"Spielplan!A10","v":"H3"},{"$f":"IF(Spielplan!C10=\"\",\"\",Spielplan!C10)","v":""},{"$f":"IF(Spielplan!I10=\"\",\"\",Spielplan!I10)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E10","v":"G3"},{"$f":"IF(Spielplan!G10=\"\",\"\",Spielplan!G10)","v":""},{"$f":"IF(Spielplan!U10=\"\",\"\",Spielplan!U10)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG10=\"\",\"\",Spielplan!AG10)","v":""},":",{"$f":"IF(Spielplan!AI10=\"\",\"\",Spielplan!AI10)","v":""},null,{"$f":"IF(Spielplan!AK10=\"\",\"\",Spielplan!AK10)","v":""},":",{"$f":"IF(Spielplan!AM10=\"\",\"\",Spielplan!AM10)","v":""}]
[null,{"$f":"Spielplan!A11","v":"H4"},{"$f":"IF(Spielplan!C11=\"\",\"\",Spielplan!C11)","v":""},{"$f":"IF(Spielplan!I11=\"\",\"\",Spielplan!I11)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E11","v":"G4"},{"$f":"IF(Spielplan!G11=\"\",\"\",Spielplan!G11)","v":""},{"$f":"IF(Spielplan!U11=\"\",\"\",Spielplan!U11)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG11=\"\",\"\",Spielplan!AG11)","v":""},":",{"$f":"IF(Spielplan!AI11=\"\",\"\",Spielplan!AI11)","v":""},null,{"$f":"IF(Spielplan!AK11=\"\",\"\",Spielplan!AK11)","v":""},":",{"$f":"IF(Spielplan!AM11=\"\",\"\",Spielplan!AM11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AI12=\"\",\"\",Spielplan!AI12)","v":""},null,{"$f":"IF(Spielplan!AK12=\"\",\"\",Spielplan!AK12)","v":""},null,{"$f":"IF(Spielplan!AM12=\"\",\"\",Spielplan!AM12)","v":""}]
["Doppel",{"$f":"Spielplan!A13","v":"H1"},{"$f":"IF(Spielplan!C13=\"\",\"\",Spielplan!C13)","v":""},{"$f":"IF(Spielplan!I13=\"\",\"\",Spielplan!I13)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E13","v":"G1"},{"$f":"IF(Spielplan!G13=\"\",\"\",Spielplan!G13)","v":""},{"$f":"IF(Spielplan!U13=\"\",\"\",Spielplan!U13)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG13=\"\",\"\",Spielplan!AG13)","v":""},":",{"$f":"IF(Spielplan!AI13=\"\",\"\",Spielplan!AI13)","v":""},null,{"$f":"IF(Spielplan!AK13=\"\",\"\",Spielplan!AK13)","v":""},":",{"$f":"IF(Spielplan!AM13=\"\",\"\",Spielplan!AM13)","v":""}]
[null,{"$f":"Spielplan!A14","v":"H3"},{"$f":"IF(Spielplan!C14=\"\",\"\",Spielplan!C14)","v":""},{"$f":"IF(Spielplan!I14=\"\",\"\",Spielplan!I14)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E14","v":"G2"},{"$f":"IF(Spielplan!G14=\"\",\"\",Spielplan!G14)","v":""},{"$f":"IF(Spielplan!U14=\"\",\"\",Spielplan!U14)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG14=\"\",\"\",Spielplan!AG14)","v":""},null,{"$f":"IF(Spielplan!AI14=\"\",\"\",Spielplan!AI14)","v":""},null,{"$f":"IF(Spielplan!AK14=\"\",\"\",Spielplan!AK14)","v":""},null,{"$f":"IF(Spielplan!AM14=\"\",\"\",Spielplan!AM14)","v":""}]
[null,{"$f":"Spielplan!A15","v":"H4"},{"$f":"IF(Spielplan!C15=\"\",\"\",Spielplan!C15)","v":""},{"$f":"IF(Spielplan!I15=\"\",\"\",Spielplan!I15)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E15","v":"G3"},{"$f":"IF(Spielplan!G15=\"\",\"\",Spielplan!G15)","v":""},{"$f":"IF(Spielplan!U15=\"\",\"\",Spielplan!U15)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG15=\"\",\"\",Spielplan!AG15)","v":""},":",{"$f":"IF(Spielplan!AI15=\"\",\"\",Spielplan!AI15)","v":""},null,{"$f":"IF(Spielplan!AK15=\"\",\"\",Spielplan!AK15)","v":""},":",{"$f":"IF(Spielplan!AM15=\"\",\"\",Spielplan!AM15)","v":""}]
[null,{"$f":"Spielplan!A16","v":"H2"},{"$f":"IF(Spielplan!C16=\"\",\"\",Spielplan!C16)","v":""},{"$f":"IF(Spielplan!I16=\"\",\"\",Spielplan!I16)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E16","v":"G4"},{"$f":"IF(Spielplan!G16=\"\",\"\",Spielplan!G16)","v":""},{"$f":"IF(Spielplan!U16=\"\",\"\",Spielplan!U16)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG16=\"\",\"\",Spielplan!AG16)","v":""},null,{"$f":"IF(Spielplan!AI16=\"\",\"\",Spielplan!AI16)","v":""},null,{"$f":"IF(Spielplan!AK16=\"\",\"\",Spielplan!AK16)","v":""},null,{"$f":"IF(Spielplan!AM16=\"\",\"\",Spielplan!AM16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AI17=\"\",\"\",Spielplan!AI17)","v":""},null,{"$f":"IF(Spielplan!AK17=\"\",\"\",Spielplan!AK17)","v":""},null,{"$f":"IF(Spielplan!AM17=\"\",\"\",Spielplan!AM17)","v":""}]
["Einzel",{"$f":"Spielplan!A18","v":"H1"},{"$f":"IF(Spielplan!C18=\"\",\"\",Spielplan!C18)","v":""},{"$f":"IF(Spielplan!I18=\"\",\"\",Spielplan!I18)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E18","v":"G2"},{"$f":"IF(Spielplan!G18=\"\",\"\",Spielplan!G18)","v":""},{"$f":"IF(Spielplan!U18=\"\",\"\",Spielplan!U18)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG18=\"\",\"\",Spielplan!AG18)","v":""},":",{"$f":"IF(Spielplan!AI18=\"\",\"\",Spielplan!AI18)","v":""},null,{"$f":"IF(Spielplan!AK18=\"\",\"\",Spielplan!AK18)","v":""},":",{"$f":"IF(Spielplan!AM18=\"\",\"\",Spielplan!AM18)","v":""}]
[null,{"$f":"Spielplan!A19","v":"H2"},{"$f":"IF(Spielplan!C19=\"\",\"\",Spielplan!C19)","v":""},{"$f":"IF(Spielplan!I19=\"\",\"\",Spielplan!I19)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E19","v":"G1"},{"$f":"IF(Spielplan!G19=\"\",\"\",Spielplan!G19)","v":""},{"$f":"IF(Spielplan!U19=\"\",\"\",Spielplan!U19)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG19=\"\",\"\",Spielplan!AG19)","v":""},":",{"$f":"IF(Spielplan!AI19=\"\",\"\",Spielplan!AI19)","v":""},null,{"$f":"IF(Spielplan!AK19=\"\",\"\",Spielplan!AK19)","v":""},":",{"$f":"IF(Spielplan!AM19=\"\",\"\",Spielplan!AM19)","v":""}]
[null,{"$f":"Spielplan!A20","v":"H3"},{"$f":"IF(Spielplan!C20=\"\",\"\",Spielplan!C20)","v":""},{"$f":"IF(Spielplan!I20=\"\",\"\",Spielplan!I20)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E20","v":"G4"},{"$f":"IF(Spielplan!G20=\"\",\"\",Spielplan!G20)","v":""},{"$f":"IF(Spielplan!U20=\"\",\"\",Spielplan!U20)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG20=\"\",\"\",Spielplan!AG20)","v":""},":",{"$f":"IF(Spielplan!AI20=\"\",\"\",Spielplan!AI20)","v":""},null,{"$f":"IF(Spielplan!AK20=\"\",\"\",Spielplan!AK20)","v":""},":",{"$f":"IF(Spielplan!AM20=\"\",\"\",Spielplan!AM20)","v":""}]
[null,{"$f":"Spielplan!A21","v":"H4"},{"$f":"IF(Spielplan!C21=\"\",\"\",Spielplan!C21)","v":""},{"$f":"IF(Spielplan!I21=\"\",\"\",Spielplan!I21)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E21","v":"G3"},{"$f":"IF(Spielplan!G21=\"\",\"\",Spielplan!G21)","v":""},{"$f":"IF(Spielplan!U21=\"\",\"\",Spielplan!U21)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG21=\"\",\"\",Spielplan!AG21)","v":""},":",{"$f":"IF(Spielplan!AI21=\"\",\"\",Spielplan!AI21)","v":""},null,{"$f":"IF(Spielplan!AK21=\"\",\"\",Spielplan!AK21)","v":""},":",{"$f":"IF(Spielplan!AM21=\"\",\"\",Spielplan!AM21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AI22=\"\",\"\",Spielplan!AI22)","v":""},null,{"$f":"IF(Spielplan!AK22=\"\",\"\",Spielplan!AK22)","v":""},null,{"$f":"IF(Spielplan!AM22=\"\",\"\",Spielplan!AM22)","v":""}]
["Doppel",{"$f":"Spielplan!A23","v":"H1"},{"$f":"IF(Spielplan!C23=\"\",\"\",Spielplan!C23)","v":""},{"$f":"IF(Spielplan!I23=\"\",\"\",Spielplan!I23)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E23","v":"G3"},{"$f":"IF(Spielplan!G23=\"\",\"\",Spielplan!G23)","v":""},{"$f":"IF(Spielplan!U23=\"\",\"\",Spielplan!U23)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG23=\"\",\"\",Spielplan!AG23)","v":""},":",{"$f":"IF(Spielplan!AI23=\"\",\"\",Spielplan!AI23)","v":""},null,{"$f":"IF(Spielplan!AK23=\"\",\"\",Spielplan!AK23)","v":""},":",{"$f":"IF(Spielplan!AM23=\"\",\"\",Spielplan!AM23)","v":""}]
[null,{"$f":"Spielplan!A24","v":"H4"},{"$f":"IF(Spielplan!C24=\"\",\"\",Spielplan!C24)","v":""},{"$f":"IF(Spielplan!I24=\"\",\"\",Spielplan!I24)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E24","v":"G4"},{"$f":"IF(Spielplan!G24=\"\",\"\",Spielplan!G24)","v":""},{"$f":"IF(Spielplan!U24=\"\",\"\",Spielplan!U24)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG24=\"\",\"\",Spielplan!AG24)","v":""},null,{"$f":"IF(Spielplan!AI24=\"\",\"\",Spielplan!AI24)","v":""},null,{"$f":"IF(Spielplan!AK24=\"\",\"\",Spielplan!AK24)","v":""},null,{"$f":"IF(Spielplan!AM24=\"\",\"\",Spielplan!AM24)","v":""}]
[null,{"$f":"Spielplan!A25","v":"H3"},{"$f":"IF(Spielplan!C25=\"\",\"\",Spielplan!C25)","v":""},{"$f":"IF(Spielplan!I25=\"\",\"\",Spielplan!I25)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E25","v":"G1"},{"$f":"IF(Spielplan!G25=\"\",\"\",Spielplan!G25)","v":""},{"$f":"IF(Spielplan!U25=\"\",\"\",Spielplan!U25)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG25=\"\",\"\",Spielplan!AG25)","v":""},":",{"$f":"IF(Spielplan!AI25=\"\",\"\",Spielplan!AI25)","v":""},null,{"$f":"IF(Spielplan!AK25=\"\",\"\",Spielplan!AK25)","v":""},":",{"$f":"IF(Spielplan!AM25=\"\",\"\",Spielplan!AM25)","v":""}]
[null,{"$f":"Spielplan!A26","v":"H2"},{"$f":"IF(Spielplan!C26=\"\",\"\",Spielplan!C26)","v":""},{"$f":"IF(Spielplan!I26=\"\",\"\",Spielplan!I26)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E26","v":"G2"},{"$f":"IF(Spielplan!G26=\"\",\"\",Spielplan!G26)","v":""},{"$f":"IF(Spielplan!U26=\"\",\"\",Spielplan!U26)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG26=\"\",\"\",Spielplan!AG26)","v":""},null,{"$f":"IF(Spielplan!AI26=\"\",\"\",Spielplan!AI26)","v":""},null,{"$f":"IF(Spielplan!AK26=\"\",\"\",Spielplan!AK26)","v":""},null,{"$f":"IF(Spielplan!AM26=\"\",\"\",Spielplan!AM26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AI27=\"\",\"\",Spielplan!AI27)","v":""},null,{"$f":"IF(Spielplan!AK27=\"\",\"\",Spielplan!AK27)","v":""},null,{"$f":"IF(Spielplan!AM27=\"\",\"\",Spielplan!AM27)","v":""}]
["Einzel",{"$f":"Spielplan!A28","v":"H1"},{"$f":"IF(Spielplan!C28=\"\",\"\",Spielplan!C28)","v":""},{"$f":"IF(Spielplan!I28=\"\",\"\",Spielplan!I28)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E28","v":"G3"},{"$f":"IF(Spielplan!G28=\"\",\"\",Spielplan!G28)","v":""},{"$f":"IF(Spielplan!U28=\"\",\"\",Spielplan!U28)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG28=\"\",\"\",Spielplan!AG28)","v":""},":",{"$f":"IF(Spielplan!AI28=\"\",\"\",Spielplan!AI28)","v":""},null,{"$f":"IF(Spielplan!AK28=\"\",\"\",Spielplan!AK28)","v":""},":",{"$f":"IF(Spielplan!AM28=\"\",\"\",Spielplan!AM28)","v":""}]
[null,{"$f":"Spielplan!A29","v":"H2"},{"$f":"IF(Spielplan!C29=\"\",\"\",Spielplan!C29)","v":""},{"$f":"IF(Spielplan!I29=\"\",\"\",Spielplan!I29)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E29","v":"G4"},{"$f":"IF(Spielplan!G29=\"\",\"\",Spielplan!G29)","v":""},{"$f":"IF(Spielplan!U29=\"\",\"\",Spielplan!U29)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG29=\"\",\"\",Spielplan!AG29)","v":""},":",{"$f":"IF(Spielplan!AI29=\"\",\"\",Spielplan!AI29)","v":""},null,{"$f":"IF(Spielplan!AK29=\"\",\"\",Spielplan!AK29)","v":""},":",{"$f":"IF(Spielplan!AM29=\"\",\"\",Spielplan!AM29)","v":""}]
[null,{"$f":"Spielplan!A30","v":"H3"},{"$f":"IF(Spielplan!C30=\"\",\"\",Spielplan!C30)","v":""},{"$f":"IF(Spielplan!I30=\"\",\"\",Spielplan!I30)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E30","v":"G1"},{"$f":"IF(Spielplan!G30=\"\",\"\",Spielplan!G30)","v":""},{"$f":"IF(Spielplan!U30=\"\",\"\",Spielplan!U30)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG30=\"\",\"\",Spielplan!AG30)","v":""},":",{"$f":"IF(Spielplan!AI30=\"\",\"\",Spielplan!AI30)","v":""},null,{"$f":"IF(Spielplan!AK30=\"\",\"\",Spielplan!AK30)","v":""},":",{"$f":"IF(Spielplan!AM30=\"\",\"\",Spielplan!AM30)","v":""}]
[null,{"$f":"Spielplan!A31","v":"H4"},{"$f":"IF(Spielplan!C31=\"\",\"\",Spielplan!C31)","v":""},{"$f":"IF(Spielplan!I31=\"\",\"\",Spielplan!I31)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Spielplan!E31","v":"G2"},{"$f":"IF(Spielplan!G31=\"\",\"\",Spielplan!G31)","v":""},{"$f":"IF(Spielplan!U31=\"\",\"\",Spielplan!U31)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG31=\"\",\"\",Spielplan!AG31)","v":""},":",{"$f":"IF(Spielplan!AI31=\"\",\"\",Spielplan!AI31)","v":""},null,{"$f":"IF(Spielplan!AK31=\"\",\"\",Spielplan!AK31)","v":""},":",{"$f":"IF(Spielplan!AM31=\"\",\"\",Spielplan!AM31)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Protest*",null,null,null,null,null,null,null,null,null,null,"Protest*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ergebnis:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legs",null,null,null,"Punkte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Spielplan!AG1=\"\",\"\",Spielplan!AG1)","v":0},":",{"$f":"IF(Spielplan!AG3=\"\",\"\",Spielplan!AG3)","v":0},null,{"$f":"IF(Spielplan!A1=\"\",\"\",Spielplan!A1)","v":0},":",{"$f":"IF(Spielplan!A3=\"\",\"\",Spielplan!A3)","v":0}]
[null,null,"(Unterschrift TC-Heim)",null,null,null,null,null,null,null,null,null,null,"(Unterschrift TC-Gast)"]
[]
[]
[null,"Innerhalb von 24 Stunden ist das Ergebnis vom Teamcaptain der Heimmannschaft in nuLiga (Schnellerfassung, nur Ergebnis) einzutragen."]
[null,"Innerhalb von 3 Werktagen ist der Bericht per E-Mail an den Ligaleiter zu senden und das komplette Spiel in nuLiga einzutragen."]
[]
[]
[]
[]
[]
["Erfassung der Highligts"]
[]
["Pos",null,"Spielername Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,"Highlights"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"180er",null,"Highfinish",null,null,null,null,"Shortlegs"]
["H1:",null,{"$f":"IF(Heim!B6=\"\",\"\",Heim!B6)","v":""}]
["H2:",null,{"$f":"IF(Heim!B7=\"\",\"\",Heim!B7)","v":""}]
["H3:",null,{"$f":"IF(Heim!B8=\"\",\"\",Heim!B8)","v":""}]
["H4:",null,{"$f":"IF(Heim!B9=\"\",\"\",Heim!B9)","v":""}]
["HE1:",null,{"$f":"IF(Heim!B10=\"\",\"\",Heim!B10)","v":""}]
["HE2:",null,{"$f":"IF(Heim!B11=\"\",\"\",Heim!B11)","v":""}]
["HE3:",null,{"$f":"IF(Heim!B12=\"\",\"\",Heim!B12)","v":""}]
["HE4:",null,{"$f":"IF(Heim!B13=\"\",\"\",Heim!B13)","v":""}]
[]
["Pos",null,"Doppelpaarungen Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,"Highlights"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"180er",null,"Highfinish",null,null,null,null,"Shortlegs"]
[{"$f":"Spielplan!A18","v":"H1"},null,{"$f":"IF(Spielplan!I18=\"\",\"\",Spielplan!I18)","v":0}]
[{"$f":"Spielplan!A19","v":"H2"},null,{"$f":"IF(Spielplan!I19=\"\",\"\",Spielplan!I19)","v":0}]
[{"$f":"Spielplan!A25","v":"H3"},null,{"$f":"IF(Spielplan!I20=\"\",\"\",Spielplan!I20)","v":0}]
[{"$f":"Spielplan!A21","v":"H4"},null,{"$f":"IF(Spielplan!I21=\"\",\"\",Spielplan!I21)","v":0}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[]
["Pos",null,"Spielername Gastmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,"Highlights"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"180er",null,"Highfinish",null,null,null,null,"Shortlegs"]
["G1:",null,{"$f":"IF(Gast!B6=\"\",\"\",Gast!B6)","v":""}]
["G2:",null,{"$f":"IF(Gast!B7=\"\",\"\",Gast!B7)","v":""}]
["G3:",null,{"$f":"IF(Gast!B8=\"\",\"\",Gast!B8)","v":""}]
["G4:",null,{"$f":"IF(Gast!B9=\"\",\"\",Gast!B9)","v":""}]
["GE1:",null,{"$f":"IF(Gast!B10=\"\",\"\",Gast!B10)","v":""}]
["GE2:",null,{"$f":"IF(Gast!B11=\"\",\"\",Gast!B11)","v":""}]
["GE3:",null,{"$f":"IF(Gast!B12=\"\",\"\",Gast!B12)","v":""}]
["GE4:",null,{"$f":"IF(Gast!B13=\"\",\"\",Gast!B13)","v":""}]
[]
["Pos",null,"Doppelpaarungen Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,"Highlights"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"180er",null,"Highfinish",null,null,null,null,"Shortlegs"]
[{"$f":"Spielplan!E18","v":"G2"},null,{"$f":"IF(Spielplan!U18=\"\",\"\",Spielplan!U18)","v":0}]
[{"$f":"Spielplan!E19","v":"G1"},null,{"$f":"IF(Spielplan!U19=\"\",\"\",Spielplan!U19)","v":0}]
[{"$f":"Spielplan!E20","v":"G4"},null,{"$f":"IF(Spielplan!U20=\"\",\"\",Spielplan!U20)","v":0}]
[{"$f":"Spielplan!E21","v":"G3"},null,{"$f":"IF(Spielplan!U21=\"\",\"\",Spielplan!U21)","v":0}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Spielplan!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(Spielplan!#REF!=\"\",\"\",Spielplan!#REF!)","v":{"$error":"#REF!"}}]